Re: autovacuum daemon question... - Mailing list pgsql-admin

From Jeff Bohmer
Subject Re: autovacuum daemon question...
Date
Msg-id p06230914bf995bb6a436@[192.168.1.200]
Whole thread Raw
In response to Re: autovacuum daemon question...  (Jeff Bohmer <jdblist@visionlink.org>)
List pgsql-admin
>AFAIK, a restart does not affect the VACUUMed-ness of anything.
>Keeping these (currently nonexistent autovacuum) stats across
>restarts would be helpful if stats_reset_on_server_start=on.


Sorry, got the meaning backwards.  The above should be
stats_reset_on_server_start=OFF.  And the below should be the
opposite, too.


>Unless I misunderstand, if stats_reset_on_server_start=off, these
>(currently nonexistent autovacuum) stats would only be relevant for
>autovacuum's VACUUM activity and not it's ANALYZE activity.


--

Jeff Bohmer
VisionLink, Inc.

pgsql-admin by date:

Previous
From: Jeff Bohmer
Date:
Subject: Re: autovacuum daemon question...
Next
From: FM
Date:
Subject: backup restore of DB + LO